Ubuntu 安装Mysql
更新最新包
sudo apt update
sudo apt -y dist-upgrade
安装常用工具
sudo apt -y install vim net-tools wget gcc make cmake lrzsz
在线安装
离线安装(Ubuntu deb)
安装依赖
在线安装
sudo apt -y install libmecab2 libjson-perl mecab-ipadic-utf8
离线安装
# 离线安装
wget http://archive.ubuntu.com/ubuntu/pool/main/m/mecab/libmecab2_0.996-14build9_amd64.deb /usr/local/mysql
sudo dpkg -i libmecab2_0.996-14build9_amd64.deb
# 离线安装
wget http://archive.ubuntu.com/ubuntu/pool/main/libj/libjson-perl/libjson-perl_4.04000-1_all.deb /usr/local/mysql
sudo dpkg -i libjson-perl_4.04000-1_all.deb
wget http://archive.ubuntu.com/ubuntu/pool/main/m/mecab-ipadic/mecab-ipadic-utf8_2.7.0-20070801+main-3_all.deb /usr/local/mysql
wget http://archive.ubuntu.com/ubuntu/pool/main/m/mecab/mecab-utils_0.996-14build9_amd64.deb /usr/local/mysql
wget http://archive.ubuntu.com/ubuntu/pool/main/m/mecab-ipadic/mecab-ipadic_2.7.0-20070801+main-3_all.deb /usr/local/mysql
sudo dpkg -i mecab-utils_0.996-14build9_amd64.deb mecab-ipadic_2.7.0-20070801+main-3_all.deb mecab-ipadic-utf8_2.7.0-20070801+main-3_all.deb
下载离线安装包
官方下载下载包:https://downloads.mysql.com/archives/community/ 这里我们选择 Product Version:8.4.0 Operating System:Ubuntu Linux OS Version:Ubuntu Linux 22.04 (x86, 64-bit)
下载:mysql-server_8.4.0-1ubuntu22.04_amd64.deb-bundle.tar
wget https://cdn.mysql.com/archives/mysql-8.4/mysql-server_8.4.0-1ubuntu22.04_amd64.deb-bundle.tar
解压
mkdir /usr/local/mysql & tar -xvf mysql-server_8.4.0-1ubuntu22.04_amd64.deb-bundle.tar -C /usr/local/mysql
安装
cd /usr/local/mysql
按顺序执行
sudo dpkg -i mysql-community-client-plugins_8.4.0-1ubuntu22.04_amd64.deb
sudo dpkg -i mysql-community-client-core_8.4.0-1ubuntu22.04_amd64.deb
sudo dpkg -i mysql-common_8.4.0-1ubuntu22.04_amd64.deb
sudo dpkg -i mysql-community-client_8.4.0-1ubuntu22.04_amd64.deb
sudo dpkg -i mysql-client_8.4.0-1ubuntu22.04_amd64.deb
sudo dpkg -i libmysqlclient24_8.4.0-1ubuntu22.04_amd64.deb
sudo dpkg -i libmysqlclient-dev_8.4.0-1ubuntu22.04_amd64.deb
sudo dpkg -i mysql-community-server-core_8.4.0-1ubuntu22.04_amd64.deb
此命令执行后会弹出窗口让你设置MySQL密码,假设密码也设置为root,设置完成后选择5.X的加密方式。
sudo dpkg -i mysql-community-server_8.4.0-1ubuntu22.04_amd64.deb
继续安装
sudo dpkg -i mysql-community-server-debug_8.4.0-1ubuntu22.04_amd64.deb
sudo dpkg -i mysql-server_8.4.0-1ubuntu22.04_amd64.deb
sudo dpkg -i mysql-community-test_8.4.0-1ubuntu22.04_amd64.deb
sudo dpkg -i mysql-community-test-debug_8.4.0-1ubuntu22.04_amd64.deb
sudo dpkg -i mysql-testsuite_8.4.0-1ubuntu22.04_amd64.deb
离线安装(Linux Generic)
下载安装包
官方下载下载包:https://downloads.mysql.com/archives/community/ 这里我们选择 Product Version:8.4.0 Operating System:Linux - Generic OS Version:Linux - Generic (glibc 2.28) (x86, 64-bit)
下载:mysql-8.4.0-linux-glibc2.28-x86_64.tar.xz 或者使用mysql-8.0.37-linux-glibc2.28-x86_64.tar.xz
wget https://cdn.mysql.com/archives/mysql-8.4/mysql-8.4.0-linux-glibc2.28-x86_64.tar.xz
离线解压安装
mysql安装路径:/usr/local/ 数据存放位置::/usr/local/data
groupadd mysql
useradd -r -g mysql mysql
tar -xvJf mysql-8.4.0-linux-glibc2.28-x86_64.tar.xz
重命名为mysql
mv mysql-8.4.0-linux-glibc2.28-x86_64 /usr/local/mysql
mkdir /usr/local/mysql/{binlog,logs,tmp,data} -p
cd /data
chgrp -R mysql .
cd /usr/local/mysql
chown -R mysql .
chgrp -R mysql .
修改环境变量
vim /etc/profile
最后一行加上
export PATH=$PATH:/usr/local/mysql/bin:/usr/local/mysql/lib
source /etc/profile
初始化mysql数据库
rm -rf /etc/my.cnf
vim /etc/my.cnf
8.4.0 之前版本
[mysql]
port = 3306
socket = /usr/local/mysql/data/mysql.sock
default-character-set = utf8mb4
[mysqld]
port = 3306
datadir = /data
basedir = /usr/local/mysql
socket = /usr/local/mysql/data/mysql.sock
tmpdir = /usr/local/mysql/tmp
user = mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links = 0
explicit_defaults_for_timestamp = true
collation_server=utf8mb4_general_ci
default-authentication-plugin=mysql_native_password
max_allowed_packet = 16M
max_connections = 1000
max_user_connections = 1000
max_connect_errors = 1000000
transaction_isolation = READ-COMMITTED
thread-cache-size = 50
open-files-limit = 65535
lower_case_table_names=1
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
group_concat_max_len=102400
character-set-server = utf8mb4
wait_timeout=1800
tmp_table_size=1G
sort_buffer_size=1048576
innodb_buffer_pool_size = 22G
innodb_buffer_pool_instances = 8
innodb_buffer_pool_load_at_startup = 1
innodb_buffer_pool_dump_at_shutdown = 1
innodb_print_all_deadlocks = 1
innodb_log_file_size = 1G
innodb_log_buffer_size = 16M
innodb_flush_log_at_trx_commit = 1
innodb_log_files_in_group = 3
innodb_log_group_home_dir = /usr/local/mysql/logs
gtid-mode=on
log-slave-updates=true
enforce-gtid-consistency=true
slave-parallel-type=LOGICAL_CLOCK
slave-parallel-workers=4
master-info-repository=TABLE
relay-log-info-repository=TABLE
sync-master-info=1
binlog-checksum=CRC32
#rpl_semi_sync_master_enabled=1
#rpl_semi_sync_master_timeout=1000
#rpl_semi_sync_master_trace_level=32
#rpl_semi_sync_master_wait_no_slave=on
log-bin = /usr/local/mysql/binlog/mysql-bin.log
expire_logs_days = 7
binlog_cache_size = 2097152
max-binlog-size=1G
log_bin_trust_function_creators = 1
sync-binlog = 1
binlog_format=row
server-id = 1
log_slave_updates=1
master_info_repository = TABLE
relay_log_info_repository = TABLE
relay_log_recovery = 1
relay_log = /usr/local/mysql/binlog/mysql-relay.log
log-error = /usr/local/mysql/logs/mysqld.log
log-queries-not-using-indexes = 0
slow-query-log = 1
slow-query-log-file = /usr/local/mysql/logs/mysql-slow.log
long_query_time = 3
lower_case_table_names = 1
[mysqld_safe]
pid-file = /usr/local/mysql/data/mysqld.pid
8.4.0 及之后的版本
[mysql]
port = 3306
socket = /usr/local/mysql/data/mysql.sock
default-character-set = utf8mb4
[mysqld]
port = 3306
datadir = /data
basedir = /usr/local/mysql
socket = /usr/local/mysql/data/mysql.sock
tmpdir = /usr/local/mysql/tmp
user = mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links = 0
explicit_defaults_for_timestamp = true
collation_server=utf8mb4_general_ci
#default-authentication-plugin=mysql_native_password
mysql_native_password=ON
max_allowed_packet = 16M
max_connections = 1000
max_user_connections = 1000
max_connect_errors = 1000000
transaction_isolation = READ-COMMITTED
thread-cache-size = 50
open-files-limit = 65535
lower_case_table_names=1
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
group_concat_max_len=102400
character-set-server = utf8mb4
wait_timeout=1800
tmp_table_size=1G
sort_buffer_size=1048576
innodb_buffer_pool_size = 22G
innodb_buffer_pool_instances = 8
innodb_buffer_pool_load_at_startup = 1
innodb_buffer_pool_dump_at_shutdown = 1
innodb_print_all_deadlocks = 1
innodb_log_file_size = 1G
innodb_log_buffer_size = 16M
innodb_flush_log_at_trx_commit = 1
innodb_log_files_in_group = 3
innodb_log_group_home_dir = /usr/local/mysql/logs
gtid-mode=on
log-slave-updates=true
enforce-gtid-consistency=true
slave-parallel-type=LOGICAL_CLOCK
slave-parallel-workers=4
sync-master-info=1
binlog-checksum=CRC32
#rpl_semi_sync_master_enabled=1
#rpl_semi_sync_master_timeout=1000
#rpl_semi_sync_master_trace_level=32
#rpl_semi_sync_master_wait_no_slave=on
log-bin = /usr/local/mysql/binlog/mysql-bin.log
binlog_cache_size = 2097152
max-binlog-size=1G
log_bin_trust_function_creators = 1
sync-binlog = 1
binlog_format=row
server-id = 1
log_slave_updates=1
relay_log_recovery = 1
relay_log = /usr/local/mysql/binlog/mysql-relay.log
log-error = /usr/local/mysql/logs/mysqld.log
log-queries-not-using-indexes = 0
slow-query-log = 1
slow-query-log-file = /usr/local/mysql/logs/mysql-slow.log
long_query_time = 3
lower_case_table_names = 1
[mysqld_safe]
pid-file = /usr/local/mysql/data/mysqld.pid
chmod 644 /etc/my.cnf
chown -R mysql:mysql /etc/my.cnf
chmod 755 /data
chown -R mysql:mysql /data
# 如果要重新初始化则需要删掉datadir下的所有文件
rm -rf /data/*
rm -rf /usr/local/mysql/data/*
rm -rf /usr/local/mysql/logs/*
touch /usr/local/mysql/logs/mysqld.log
chown -R mysql:mysql /usr/local/mysql/logs/
# 初始化配置
mysqld --defaults-file=/etc/my.cnf --initialize
# 开启mysql服务
ln -s /usr/local/mysql/bin/mysql /usr/bin
# mysqld_safe方式启动
/usr/local/mysql/bin/mysqld_safe --defaults-file=/etc/my.cnf --user=mysql > /usr/local/mysql/logs/mysqld_safe.log 2>&1 &
or 或者直接启动
service mysql start
service mysql stop
查询Mysql服务,如果是mysqld_safe方式是查不到的
systemctl status mysql #查看mysql的服务状态
systemctl restart mysqld #重启mysql服务
从以上命令的返回结果中获取localhost初始密码
cat /usr/local/mysql/logs/mysqld.log
修改密码和可访问主机地址
mysql -uroot -p
-- 先改密码之后才能查询mysql.user
ALTER USER 'root'@'localhost' IDENTIFIED BY '密码';
flush privileges;
select host , user , plugin ,authentication_string from mysql.user;
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '密码';
flush privileges;
update mysql.user set host = '%',plugin='mysql_native_password' where user='root';
flush privileges;
quit;
放行防火墙
firewall-cmd --add-port=3306/tcp --permanent
firewall-cmd --reload
设置自动启动
vim /etc/systemd/system/mysql.service
修改为我们自定义的配置
[Unit]
Description=MySQL Server
After=network.service
[Install]
WantedBy=multi-user.target
[Service]
User=mysql
Group=mysql
Type=forking
TimeoutSec=0
PermissionsStartOnly=true
ExecStart=/usr/local/mysql/bin/mysqld_safe --defaults-file=/etc/my.cnf --user=mysql --log-error=/usr/local/mysql/logs/mysqld_safe.log
LimitNOFILE=5000
Restart=on-failure
RestartSec=10
RestartPreventExitStatus=1
PrivateTmp=false
# 重载系统服务
systemctl daemon-reload
# 实现开机自启
systemctl enable mysql
关闭SELINUX:
vim /etc/selinux/config
#SELINUX=enforcing 修改为 SELINUX=disabled
重启服务器验证
reboot
#重新连接服务器,查看mysql 服务的状态:
systemctl status mysql
#查看端口
netstat -tnap
#查看mysql启动情况
ps aux|grep mysql